package com.orange.handler.impl;

import java.sql.SQLException;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.orange.handler.AuthSchoolExpertFileService;
import com.orange.modules.dao.AuthSchoolExpertFileRepository;
import com.orange.modules.entity.AuthSchoolExpertFile;

@Service
public class AuthSchoolExpertFileServiceImpl implements AuthSchoolExpertFileService{

	@Autowired
	private AuthSchoolExpertFileRepository authSchoolExpertFileRepository;

	@Override
	public void insertAuthSchoolExpertFile(AuthSchoolExpertFile as)
			throws SQLException {
		// TODO Auto-generated method stub
		authSchoolExpertFileRepository.insertAuthSchoolExpertFile(as);
	}

	@Override
	public List<AuthSchoolExpertFile> queryFileByschoolIdExpertId(String sid,
			String expertId) throws SQLException{
		// TODO Auto-generated method stub
		List<AuthSchoolExpertFile> list = authSchoolExpertFileRepository.queryFileByschoolIdExpertId(sid, expertId);
		return list;
	}

	@Override
	public void deleteAuthSchoolExpertFile(String pid)
			throws SQLException {
		// TODO Auto-generated method stub
		authSchoolExpertFileRepository.deleteAuthSchoolExpertFile(pid);
	}
	
	
}
